{
 "metadata": {
  "name": "",
  "signature": "sha256:e4105945ddbf0ad8c536655c36c60f3b2b7b34fcedeeec2042810f4b2d1a5a5d"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd\n",
      "import numpy as nm"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 1
    },
    {
     "cell_type": "heading",
     "level": 1,
     "metadata": {},
     "source": [
      "UCLA - LoPukci Bankruptcy Research Database"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "brd_location = \"UCLA-LoPucki Bankruptcy Research Database.csv\"\n",
      "brd = pd.read_csv(brd_location, encoding='cp1252')\n",
      "brd.sort('XYearFiled', ascending=False)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>XNameCorp</th>\n",
        "      <th>AfterEmerging</th>\n",
        "      <th>Assets1Before</th>\n",
        "      <th>Assets2Before</th>\n",
        "      <th>Assets3Before</th>\n",
        "      <th>AssetsBefore</th>\n",
        "      <th>AssetsCurrDollar</th>\n",
        "      <th>AssetsEmerging</th>\n",
        "      <th>AssetsPetCurrDollar</th>\n",
        "      <th>AssetsPetition</th>\n",
        "      <th>...</th>\n",
        "      <th>XPrepackaged</th>\n",
        "      <th>XShop</th>\n",
        "      <th>XSICMajGroup</th>\n",
        "      <th>XTortCause</th>\n",
        "      <th>XVoluntary</th>\n",
        "      <th>XYearDisposed</th>\n",
        "      <th>XYearEmerged</th>\n",
        "      <th>XYearFiled</th>\n",
        "      <th>YearConfirmed</th>\n",
        "      <th>YearsToRefile</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0  </th>\n",
        "      <td>                            1st Centennial Bancorp</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>   690.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    690.000000</td>\n",
        "      <td>    762</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                        60 Depository Institutions</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td> voluntary Chapter 7</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2009</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>1  </th>\n",
        "      <td>                        A. H. Robins, Incorporated</td>\n",
        "      <td> Became a subsidiary of American Home Products ...</td>\n",
        "      <td>    648.000000</td>\n",
        "      <td>   509.663</td>\n",
        "      <td>  439.983</td>\n",
        "      <td>    648.000000</td>\n",
        "      <td>   1409</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>   1013.036537</td>\n",
        "      <td>    466.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                  28 Chemicals and Allied Products</td>\n",
        "      <td> Other products</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1988</td>\n",
        "      <td> 1988</td>\n",
        "      <td> 1985</td>\n",
        "      <td> 1988</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>2  </th>\n",
        "      <td>                                A123 Systems, Inc.</td>\n",
        "      <td> assets acquired by Wanxiang America Corporatio...</td>\n",
        "      <td>    625.902000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    625.902000</td>\n",
        "      <td>    635</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    466.680486</td>\n",
        "      <td>    459.795</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 36 Electronic And Other Electrical Equipment A...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2013</td>\n",
        "      <td> 2012</td>\n",
        "      <td> 2012</td>\n",
        "      <td> 2013</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>3  </th>\n",
        "      <td>                                    aaiPharma Inc.</td>\n",
        "      <td> Acquired by Xanodyne in 2005 and operated sepa...</td>\n",
        "      <td>    339.070000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    339.070000</td>\n",
        "      <td>    410</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    390.484039</td>\n",
        "      <td>    323.323</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 87 Engineering, Accounting, Research, Manageme...</td>\n",
        "      <td>         Fraud?</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2006</td>\n",
        "      <td> 2006</td>\n",
        "      <td> 2005</td>\n",
        "      <td> 2006</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>4  </th>\n",
        "      <td>                                    ABC-NACO, Inc.</td>\n",
        "      <td> acquired by Three Cities Research, Inc. and Ce...</td>\n",
        "      <td>    474.100000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    474.100000</td>\n",
        "      <td>    626</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    506.177002</td>\n",
        "      <td>    383.113</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td> 34 Fabricated Metal Products, Except Machinery...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2004</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2001</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>5  </th>\n",
        "      <td>                               AbitibiBowater Inc.</td>\n",
        "      <td> 11/7/2011 name change to Resolute Forest Products</td>\n",
        "      <td>   8072.000000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   8072.000000</td>\n",
        "      <td>   8889</td>\n",
        "      <td>  7156.000</td>\n",
        "      <td>  10942.864900</td>\n",
        "      <td>   9937.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                      26 Paper and Allied Products</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2009</td>\n",
        "      <td> 2010</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>6  </th>\n",
        "      <td>               Acceptance Insurance Companies Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>   279.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    279.000000</td>\n",
        "      <td>    343</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>     40.713020</td>\n",
        "      <td>     33.069</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                             63 Insurance Carriers</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2010</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2005</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>7  </th>\n",
        "      <td>                              Accuride Corporation</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    808.550000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    808.550000</td>\n",
        "      <td>    878</td>\n",
        "      <td>   874.050</td>\n",
        "      <td>    740.899118</td>\n",
        "      <td>    682.263</td>\n",
        "      <td>...</td>\n",
        "      <td> prenegotiated</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                       37 Transportation Equipment</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2009</td>\n",
        "      <td> 2010</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>8  </th>\n",
        "      <td>                         Acme Metals, Incorporated</td>\n",
        "      <td> compact strip process mini-mill sold to Intern...</td>\n",
        "      <td>    829.000000</td>\n",
        "      <td>   806.000</td>\n",
        "      <td>  755.000</td>\n",
        "      <td>    829.000000</td>\n",
        "      <td>   1190</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>   1167.734106</td>\n",
        "      <td>    813.700</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                       33 Primary Metal Industries</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2002</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 1998</td>\n",
        "      <td> 2002</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>9  </th>\n",
        "      <td>                           ACT Manufacturing, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>   1067.800000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   1067.800000</td>\n",
        "      <td>   1419</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 36 Electronic And Other Electrical Equipment A...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2003</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2003</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>10 </th>\n",
        "      <td>                                     Acterna Corp.</td>\n",
        "      <td>             Acquired by JDS Uniphase Corp, 5/2005</td>\n",
        "      <td>    406.156000</td>\n",
        "      <td>  1015.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    406.156000</td>\n",
        "      <td>    520</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    547.563029</td>\n",
        "      <td>    427.964</td>\n",
        "      <td>...</td>\n",
        "      <td> prenegotiated</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 38 Measuring, Analyzing and Controlling Instru...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2003</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>11 </th>\n",
        "      <td>                 Adelphia Business Solutions, Inc.</td>\n",
        "      <td>      acquired by Level 3 Communications 7/24/2006</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>  1890.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   1890.000000</td>\n",
        "      <td>   2482</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    292.374565</td>\n",
        "      <td>    222.661</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>          Fraud</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2003</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>12 </th>\n",
        "      <td>                     Adelphia Communications Corp.</td>\n",
        "      <td>       assets sold to Comcast and TWC on 7-31-2007</td>\n",
        "      <td>           NaN</td>\n",
        "      <td> 21499.480</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>  21499.480000</td>\n",
        "      <td>  28058</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>  31856.169280</td>\n",
        "      <td>  24409.662</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>          Fraud</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2007</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2007</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>13 </th>\n",
        "      <td>                     Advanced GlassFiber Yarns LLC</td>\n",
        "      <td>          Acquired by Kohlberg &amp; Co. LLC 3/31/2006</td>\n",
        "      <td>    412.480000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    412.480000</td>\n",
        "      <td>    535</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    251.912615</td>\n",
        "      <td>    194.100</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>      32 Stone, Clay, Glass, And Concrete Products</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2004</td>\n",
        "      <td> 2004</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2004</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>14 </th>\n",
        "      <td>                      Advanced Radio Telecom Corp.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    455.834000</td>\n",
        "      <td>   398.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    455.834000</td>\n",
        "      <td>    605</td>\n",
        "      <td>    53.694</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2001</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>15 </th>\n",
        "      <td>                                     Advanta Corp.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>   3585.045000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   3585.045000</td>\n",
        "      <td>   3893</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    394.197516</td>\n",
        "      <td>    363.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>             61 Non-depository Credit Institutions</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2011</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2009</td>\n",
        "      <td> 2011</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>16 </th>\n",
        "      <td>     Affiliated Media, Inc. (MediaNews Group Inc.)</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>       NaN</td>\n",
        "      <td> 2595.000</td>\n",
        "      <td>   2595.000000</td>\n",
        "      <td>   2812</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>           yes</td>\n",
        "      <td> Yes</td>\n",
        "      <td>    27 Printing, Publishing, And Allied Industries</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>17 </th>\n",
        "      <td>                             AgriBioTech, Inc., NV</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    342.129000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    342.129000</td>\n",
        "      <td>    476</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                                          01 Crops</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2001</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2000</td>\n",
        "      <td> 2001</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>18 </th>\n",
        "      <td>                                        Agway Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>   1574.400000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   1574.400000</td>\n",
        "      <td>   2039</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                      20 Food and Kindred Products</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2004</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2004</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>19 </th>\n",
        "      <td>                               Ahern Rentals, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>   628.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    628.000000</td>\n",
        "      <td>    653</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                              73 Business Services</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2013</td>\n",
        "      <td> 2013</td>\n",
        "      <td> 2011</td>\n",
        "      <td> 2013</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>20 </th>\n",
        "      <td>                           Air Florida System Inc.</td>\n",
        "      <td> Assets sold to Midway Airlines; purchased Poco...</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>   229.000</td>\n",
        "      <td>  402.021</td>\n",
        "      <td>    229.000000</td>\n",
        "      <td>    516</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    390.173996</td>\n",
        "      <td>    173.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                          45 Transportation By Air</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1986</td>\n",
        "      <td> 1984</td>\n",
        "      <td> 1984</td>\n",
        "      <td> 1986</td>\n",
        "      <td>  3.693150</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>21 </th>\n",
        "      <td>                     Al Copeland Enterprises, Inc.</td>\n",
        "      <td> Still existing to 1996; changed name to AFC En...</td>\n",
        "      <td>    427.461000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    427.461000</td>\n",
        "      <td>    742</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    932.698780</td>\n",
        "      <td>    537.100</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                     58 Eating and Drinking Places</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>         involuntary</td>\n",
        "      <td> 1992</td>\n",
        "      <td> 1992</td>\n",
        "      <td> 1991</td>\n",
        "      <td> 1992</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>22 </th>\n",
        "      <td>                        Aleris International, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>  5120.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   5120.000000</td>\n",
        "      <td>   5665</td>\n",
        "      <td>  1779.700</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                       33 Primary Metal Industries</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2009</td>\n",
        "      <td> 2010</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>23 </th>\n",
        "      <td>                                   Alexanders Inc.</td>\n",
        "      <td> No longer a department store; continuing as a ...</td>\n",
        "      <td>    188.057000</td>\n",
        "      <td>   198.993</td>\n",
        "      <td>  208.000</td>\n",
        "      <td>    188.057000</td>\n",
        "      <td>    316</td>\n",
        "      <td>    92.917</td>\n",
        "      <td>    307.551346</td>\n",
        "      <td>    183.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                     53 General Merchandise Stores</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1993</td>\n",
        "      <td> 1993</td>\n",
        "      <td> 1992</td>\n",
        "      <td> 1993</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>24 </th>\n",
        "      <td>                     Allegheny International, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    850.488000</td>\n",
        "      <td>  1282.620</td>\n",
        "      <td> 1511.000</td>\n",
        "      <td>    850.488000</td>\n",
        "      <td>   1721</td>\n",
        "      <td>   889.800</td>\n",
        "      <td>   2586.638948</td>\n",
        "      <td>   1278.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td> 36 Electronic And Other Electrical Equipment A...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1990</td>\n",
        "      <td> 1990</td>\n",
        "      <td> 1988</td>\n",
        "      <td> 1990</td>\n",
        "      <td> 10.580821</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>25 </th>\n",
        "      <td>                           Allegiance Telecom Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>   1441.200000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   1441.200000</td>\n",
        "      <td>   1844</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>   1843.981489</td>\n",
        "      <td>   1441.218</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2004</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2004</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>26 </th>\n",
        "      <td>                      Alliance Entertainment Corp.</td>\n",
        "      <td> Acquired by Yucaipa Companies, LA Investment c...</td>\n",
        "      <td>    613.000000</td>\n",
        "      <td>   645.000</td>\n",
        "      <td>  403.000</td>\n",
        "      <td>    613.000000</td>\n",
        "      <td>    897</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    748.958704</td>\n",
        "      <td>    512.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                  50 Wholesale Trade-durable Goods</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1998</td>\n",
        "      <td> 1998</td>\n",
        "      <td> 1997</td>\n",
        "      <td> 1998</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>27 </th>\n",
        "      <td>                             Allied Holdings, Inc.</td>\n",
        "      <td> Operates as Allied Automotive Group, Inc. and ...</td>\n",
        "      <td>    421.000000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    421.000000</td>\n",
        "      <td>    506</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    158.874885</td>\n",
        "      <td>    132.226</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>   42 Motor Freight Transportation And Warehousing</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2007</td>\n",
        "      <td> 2007</td>\n",
        "      <td> 2005</td>\n",
        "      <td> 2007</td>\n",
        "      <td>  5.002739</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>28 </th>\n",
        "      <td>                             Allied Products Corp.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    256.611000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    256.611000</td>\n",
        "      <td>    346</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    185.510723</td>\n",
        "      <td>    137.485</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td> 35 Industrial and Commercial Machinery and Com...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2003</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2000</td>\n",
        "      <td> 2003</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>29 </th>\n",
        "      <td> Allied Stores Corporation (Federated Departmen...</td>\n",
        "      <td>                           Acquired Macy's in 1994</td>\n",
        "      <td>   3502.000000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   3502.000000</td>\n",
        "      <td>   6454</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>  20640.087910</td>\n",
        "      <td>  11200.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                     53 General Merchandise Stores</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1992</td>\n",
        "      <td> 1992</td>\n",
        "      <td> 1990</td>\n",
        "      <td> 1992</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>...</th>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>965</th>\n",
        "      <td>                     WestPoint Stevens Inc. (2003)</td>\n",
        "      <td> acquired by American Real Estate Partners LP (...</td>\n",
        "      <td>   1297.200000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   1297.200000</td>\n",
        "      <td>   1658</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>   1706.135762</td>\n",
        "      <td>   1334.934</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 23 Apparel And Other Finished Products Made Fr...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2012</td>\n",
        "      <td> 2005</td>\n",
        "      <td> 2003</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>966</th>\n",
        "      <td>                  Wheeling Pittsburgh Corp. (2000)</td>\n",
        "      <td> Name changes to WHX corporation; Handy &amp; Harma...</td>\n",
        "      <td>   1272.022000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   1272.022000</td>\n",
        "      <td>   1715</td>\n",
        "      <td>   878.769</td>\n",
        "      <td>   1618.249282</td>\n",
        "      <td>   1200.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                       33 Primary Metal Industries</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2000</td>\n",
        "      <td> 2003</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>967</th>\n",
        "      <td>            Wheeling-Pittsburgh Steel Corp. (1985)</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>   1219.675000</td>\n",
        "      <td>  1241.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   1219.675000</td>\n",
        "      <td>   2679</td>\n",
        "      <td>  1218.381</td>\n",
        "      <td>   2415.894294</td>\n",
        "      <td>   1100.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                       33 Primary Metal Industries</td>\n",
        "      <td>        Pension</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1990</td>\n",
        "      <td> 1990</td>\n",
        "      <td> 1985</td>\n",
        "      <td> 1990</td>\n",
        "      <td>  9.920547</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>968</th>\n",
        "      <td>             Wherehouse Entertainment, Inc. (1995)</td>\n",
        "      <td> change name to Wherehouse Entertainment, Inc. New</td>\n",
        "      <td>    197.700000</td>\n",
        "      <td>   351.000</td>\n",
        "      <td>  374.000</td>\n",
        "      <td>    197.700000</td>\n",
        "      <td>    304</td>\n",
        "      <td>   131.742</td>\n",
        "      <td>    270.251511</td>\n",
        "      <td>    176.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 57 Home Furniture, Furnishings, and Equipment ...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1997</td>\n",
        "      <td> 1997</td>\n",
        "      <td> 1995</td>\n",
        "      <td> 1997</td>\n",
        "      <td>  6.038356</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>969</th>\n",
        "      <td>             Wherehouse Entertainment, Inc. (2003)</td>\n",
        "      <td> acquired by Trans World Entertainment Corporat...</td>\n",
        "      <td>    229.075000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    229.075000</td>\n",
        "      <td>    296</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    294.551307</td>\n",
        "      <td>    227.957</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 57 Home Furniture, Furnishings, and Equipment ...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2004</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2004</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>970</th>\n",
        "      <td>                                 White Motor Corp.</td>\n",
        "      <td>    Name changed to Neoax and then to EnviroSource</td>\n",
        "      <td>    630.150000</td>\n",
        "      <td>   617.763</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    630.150000</td>\n",
        "      <td>   1761</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>   2508.523185</td>\n",
        "      <td>    897.500</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                       37 Transportation Equipment</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1983</td>\n",
        "      <td> 1983</td>\n",
        "      <td> 1980</td>\n",
        "      <td> 1983</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>971</th>\n",
        "      <td>                                   WHX Corporation</td>\n",
        "      <td>            name change to Handy &amp; Harman 1-3-2011</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>   406.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    406.000000</td>\n",
        "      <td>    493</td>\n",
        "      <td>   296.213</td>\n",
        "      <td>    494.187891</td>\n",
        "      <td>    406.875</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td> 34 Fabricated Metal Products, Except Machinery...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2005</td>\n",
        "      <td> 2005</td>\n",
        "      <td> 2005</td>\n",
        "      <td> 2005</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>972</th>\n",
        "      <td>                            Wickes Companies, Inc.</td>\n",
        "      <td> Acquired Collins and Aikman Group 1987 and cha...</td>\n",
        "      <td>   1939.100000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   1939.100000</td>\n",
        "      <td>   4797</td>\n",
        "      <td>  1313.008</td>\n",
        "      <td>   4218.883449</td>\n",
        "      <td>   1705.300</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td> 52 Building Materials, Hardware, Garden Supply...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1984</td>\n",
        "      <td> 1984</td>\n",
        "      <td> 1982</td>\n",
        "      <td> 1984</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>973</th>\n",
        "      <td>                                William Lyon Homes</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    649.004000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    649.004000</td>\n",
        "      <td>    675</td>\n",
        "      <td>   581.147</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>           yes</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 15 Building Construction General Contractors A...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2012</td>\n",
        "      <td> 2012</td>\n",
        "      <td> 2011</td>\n",
        "      <td> 2012</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>974</th>\n",
        "      <td>               Williams Communications Group, Inc.</td>\n",
        "      <td> Name to change to WilTel Communications Group,...</td>\n",
        "      <td>   5992.000000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   5992.000000</td>\n",
        "      <td>   7824</td>\n",
        "      <td>  2062.273</td>\n",
        "      <td>   7824.326231</td>\n",
        "      <td>   5992.026</td>\n",
        "      <td>...</td>\n",
        "      <td> prenegotiated</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>975</th>\n",
        "      <td>           Wilshire Financial Services Group, Inc.</td>\n",
        "      <td>          Operating successfully as of August 2004</td>\n",
        "      <td>   1084.253000</td>\n",
        "      <td>  1629.000</td>\n",
        "      <td>  754.000</td>\n",
        "      <td>   1084.253000</td>\n",
        "      <td>   1543</td>\n",
        "      <td>   787.287</td>\n",
        "      <td>    167.958059</td>\n",
        "      <td>    118.038</td>\n",
        "      <td>...</td>\n",
        "      <td>           yes</td>\n",
        "      <td> Yes</td>\n",
        "      <td>             61 Non-depository Credit Institutions</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1999</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>976</th>\n",
        "      <td>                         Wilson Foods Corp. (1983)</td>\n",
        "      <td> Became subsidiary of Doskocil 10/17/88 and ref...</td>\n",
        "      <td>    284.800000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    284.800000</td>\n",
        "      <td>    678</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    701.247510</td>\n",
        "      <td>    294.500</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                      20 Food and Kindred Products</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1984</td>\n",
        "      <td> 1984</td>\n",
        "      <td> 1983</td>\n",
        "      <td> 1984</td>\n",
        "      <td>  5.939726</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>977</th>\n",
        "      <td>                           Winn-Dixie Stores, Inc.</td>\n",
        "      <td>                                        Continuing</td>\n",
        "      <td>   2619.000000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   2619.000000</td>\n",
        "      <td>   3206</td>\n",
        "      <td>  1670.891</td>\n",
        "      <td>   2737.071512</td>\n",
        "      <td>   2236.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                    54 Food Stores</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2006</td>\n",
        "      <td> 2006</td>\n",
        "      <td> 2005</td>\n",
        "      <td> 2006</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>978</th>\n",
        "      <td>                      Winstar Communications, Inc.</td>\n",
        "      <td> acquired by IDT Corp in 2001 and made a subsid...</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>  3065.000</td>\n",
        "      <td> 1663.000</td>\n",
        "      <td>   3065.000000</td>\n",
        "      <td>   4068</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2001</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>979</th>\n",
        "      <td>                                Wireless One, Inc.</td>\n",
        "      <td>              Acquired by Worldcom from bankruptcy</td>\n",
        "      <td>    227.193000</td>\n",
        "      <td>   318.000</td>\n",
        "      <td>  396.000</td>\n",
        "      <td>    227.193000</td>\n",
        "      <td>    324</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    398.050134</td>\n",
        "      <td>    278.895</td>\n",
        "      <td>...</td>\n",
        "      <td> prenegotiated</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1999</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>980</th>\n",
        "      <td>                                   WKI Holding Co.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    831.800000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    831.800000</td>\n",
        "      <td>   1086</td>\n",
        "      <td>   742.773</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td> prenegotiated</td>\n",
        "      <td> Yes</td>\n",
        "      <td>      32 Stone, Clay, Glass, And Concrete Products</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>981</th>\n",
        "      <td>                                World Access, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>  1630.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   1630.000000</td>\n",
        "      <td>   2163</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>   2230.203167</td>\n",
        "      <td>   1680.387</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 36 Electronic And Other Electrical Equipment A...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>         involuntary</td>\n",
        "      <td> 2004</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2004</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>982</th>\n",
        "      <td>                                    Worldcom, Inc.</td>\n",
        "      <td>          MCI negative earnings 2004, no data 2005</td>\n",
        "      <td> 103914.000000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td> 103914.000000</td>\n",
        "      <td> 135464</td>\n",
        "      <td> 27470.000</td>\n",
        "      <td> 139486.768500</td>\n",
        "      <td> 107000.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>          Fraud</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2003</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2003</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>983</th>\n",
        "      <td>                            Worlds of Wonder, Inc.</td>\n",
        "      <td> sold to group led by  Eli S. Jacobs; continued...</td>\n",
        "      <td>    273.000000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    273.000000</td>\n",
        "      <td>    555</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    638.018385</td>\n",
        "      <td>    313.600</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                           59 Miscellaneous Retail</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1989</td>\n",
        "      <td> 1989</td>\n",
        "      <td> 1987</td>\n",
        "      <td> 1989</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>984</th>\n",
        "      <td>                                  WorldSpace, Inc.</td>\n",
        "      <td>                 Assets purchased by Yazmi USA LLC</td>\n",
        "      <td>    340.014000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    340.014000</td>\n",
        "      <td>    369</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    333.183072</td>\n",
        "      <td>    307.382</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2012</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2008</td>\n",
        "      <td>  NaN</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>985</th>\n",
        "      <td>                                    Worldtex, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>   314.000</td>\n",
        "      <td>  324.000</td>\n",
        "      <td>    314.000000</td>\n",
        "      <td>    418</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td> prenegotiated</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                          22 Textile Mill Products</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2002</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>986</th>\n",
        "      <td>                               WTD Industries Inc.</td>\n",
        "      <td>       Changed name to TreeSource Industries 10/98</td>\n",
        "      <td>    220.930000</td>\n",
        "      <td>   184.900</td>\n",
        "      <td>  146.000</td>\n",
        "      <td>    220.930000</td>\n",
        "      <td>    385</td>\n",
        "      <td>   100.039</td>\n",
        "      <td>    267.224734</td>\n",
        "      <td>    153.200</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td> Yes</td>\n",
        "      <td>     24 Lumber And Wood Products, Except Furniture</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1992</td>\n",
        "      <td> 1992</td>\n",
        "      <td> 1991</td>\n",
        "      <td> 1992</td>\n",
        "      <td>  6.846575</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>987</th>\n",
        "      <td>                         Xerium Technologies, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    693.511000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    693.511000</td>\n",
        "      <td>    748</td>\n",
        "      <td>   700.143</td>\n",
        "      <td>    748.161825</td>\n",
        "      <td>    693.511</td>\n",
        "      <td>...</td>\n",
        "      <td>           yes</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                          22 Textile Mill Products</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>988</th>\n",
        "      <td>                           XO Communications, Inc.</td>\n",
        "      <td> Name change to XO Holdings 2-28-2006; 5 years ...</td>\n",
        "      <td>   7930.500000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>   7930.500000</td>\n",
        "      <td>  10350</td>\n",
        "      <td>  1348.090</td>\n",
        "      <td>  11354.056140</td>\n",
        "      <td>   8700.000</td>\n",
        "      <td>...</td>\n",
        "      <td> prenegotiated</td>\n",
        "      <td> Yes</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td> 2002</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>989</th>\n",
        "      <td>                                     Xpedior, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>   262.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    262.000000</td>\n",
        "      <td>    348</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>     66.359808</td>\n",
        "      <td>     50.000</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                              73 Business Services</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2002</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2002</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>990</th>\n",
        "      <td>                               York Research Corp.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    263.500000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    263.500000</td>\n",
        "      <td>    350</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>           49 Electric, Gas, And Sanitary Services</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>         involuntary</td>\n",
        "      <td> 2002</td>\n",
        "      <td>  NaN</td>\n",
        "      <td> 2001</td>\n",
        "      <td> 2002</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>991</th>\n",
        "      <td>                          Young Broadcasting, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>    348.222526</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    348.222526</td>\n",
        "      <td>    385</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>    636.851761</td>\n",
        "      <td>    575.600</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                                 48 Communications</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2010</td>\n",
        "      <td> 2009</td>\n",
        "      <td> 2010</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>992</th>\n",
        "      <td>                                        Zale Corp.</td>\n",
        "      <td>                                   Prosperous 2001</td>\n",
        "      <td>   1789.178000</td>\n",
        "      <td>  2013.247</td>\n",
        "      <td> 1450.000</td>\n",
        "      <td>   1789.178000</td>\n",
        "      <td>   3042</td>\n",
        "      <td>  1013.523</td>\n",
        "      <td>   3021.891582</td>\n",
        "      <td>   1777.500</td>\n",
        "      <td>...</td>\n",
        "      <td>            no</td>\n",
        "      <td>  No</td>\n",
        "      <td>                           59 Miscellaneous Retail</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>         involuntary</td>\n",
        "      <td> 1993</td>\n",
        "      <td> 1993</td>\n",
        "      <td> 1992</td>\n",
        "      <td> 1993</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>993</th>\n",
        "      <td>                          Zenith Electronics Corp.</td>\n",
        "      <td> Acquired by LGE at confirmation, subsidiary, w...</td>\n",
        "      <td>    350.000000</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    350.000000</td>\n",
        "      <td>    492</td>\n",
        "      <td>   148.300</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td>           yes</td>\n",
        "      <td> Yes</td>\n",
        "      <td> 36 Electronic And Other Electrical Equipment A...</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1999</td>\n",
        "      <td> 1999</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>994</th>\n",
        "      <td>                            Ziff Davis Media, Inc.</td>\n",
        "      <td>                                               NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>   300.000</td>\n",
        "      <td>      NaN</td>\n",
        "      <td>    300.000000</td>\n",
        "      <td>    330</td>\n",
        "      <td>       NaN</td>\n",
        "      <td>           NaN</td>\n",
        "      <td>        NaN</td>\n",
        "      <td>...</td>\n",
        "      <td> prenegotiated</td>\n",
        "      <td>  No</td>\n",
        "      <td>    27 Printing, Publishing, And Allied Industries</td>\n",
        "      <td>       Not tort</td>\n",
        "      <td>           voluntary</td>\n",
        "      <td> 2008</td>\n",
        "      <td> 2008</td>\n",
        "      <td> 2008</td>\n",
        "      <td> 2008</td>\n",
        "      <td>       NaN</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>995 rows \u00d7 203 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 5,
       "text": [
        "                                             XNameCorp  \\\n",
        "0                               1st Centennial Bancorp   \n",
        "1                           A. H. Robins, Incorporated   \n",
        "2                                   A123 Systems, Inc.   \n",
        "3                                       aaiPharma Inc.   \n",
        "4                                       ABC-NACO, Inc.   \n",
        "5                                  AbitibiBowater Inc.   \n",
        "6                  Acceptance Insurance Companies Inc.   \n",
        "7                                 Accuride Corporation   \n",
        "8                            Acme Metals, Incorporated   \n",
        "9                              ACT Manufacturing, Inc.   \n",
        "10                                       Acterna Corp.   \n",
        "11                   Adelphia Business Solutions, Inc.   \n",
        "12                       Adelphia Communications Corp.   \n",
        "13                       Advanced GlassFiber Yarns LLC   \n",
        "14                        Advanced Radio Telecom Corp.   \n",
        "15                                       Advanta Corp.   \n",
        "16       Affiliated Media, Inc. (MediaNews Group Inc.)   \n",
        "17                               AgriBioTech, Inc., NV   \n",
        "18                                          Agway Inc.   \n",
        "19                                 Ahern Rentals, Inc.   \n",
        "20                             Air Florida System Inc.   \n",
        "21                       Al Copeland Enterprises, Inc.   \n",
        "22                          Aleris International, Inc.   \n",
        "23                                     Alexanders Inc.   \n",
        "24                       Allegheny International, Inc.   \n",
        "25                             Allegiance Telecom Inc.   \n",
        "26                        Alliance Entertainment Corp.   \n",
        "27                               Allied Holdings, Inc.   \n",
        "28                               Allied Products Corp.   \n",
        "29   Allied Stores Corporation (Federated Departmen...   \n",
        "..                                                 ...   \n",
        "965                      WestPoint Stevens Inc. (2003)   \n",
        "966                   Wheeling Pittsburgh Corp. (2000)   \n",
        "967             Wheeling-Pittsburgh Steel Corp. (1985)   \n",
        "968              Wherehouse Entertainment, Inc. (1995)   \n",
        "969              Wherehouse Entertainment, Inc. (2003)   \n",
        "970                                  White Motor Corp.   \n",
        "971                                    WHX Corporation   \n",
        "972                             Wickes Companies, Inc.   \n",
        "973                                 William Lyon Homes   \n",
        "974                Williams Communications Group, Inc.   \n",
        "975            Wilshire Financial Services Group, Inc.   \n",
        "976                          Wilson Foods Corp. (1983)   \n",
        "977                            Winn-Dixie Stores, Inc.   \n",
        "978                       Winstar Communications, Inc.   \n",
        "979                                 Wireless One, Inc.   \n",
        "980                                    WKI Holding Co.   \n",
        "981                                 World Access, Inc.   \n",
        "982                                     Worldcom, Inc.   \n",
        "983                             Worlds of Wonder, Inc.   \n",
        "984                                   WorldSpace, Inc.   \n",
        "985                                     Worldtex, Inc.   \n",
        "986                                WTD Industries Inc.   \n",
        "987                          Xerium Technologies, Inc.   \n",
        "988                            XO Communications, Inc.   \n",
        "989                                      Xpedior, Inc.   \n",
        "990                                York Research Corp.   \n",
        "991                           Young Broadcasting, Inc.   \n",
        "992                                         Zale Corp.   \n",
        "993                           Zenith Electronics Corp.   \n",
        "994                             Ziff Davis Media, Inc.   \n",
        "\n",
        "                                         AfterEmerging  Assets1Before  \\\n",
        "0                                                  NaN            NaN   \n",
        "1    Became a subsidiary of American Home Products ...     648.000000   \n",
        "2    assets acquired by Wanxiang America Corporatio...     625.902000   \n",
        "3    Acquired by Xanodyne in 2005 and operated sepa...     339.070000   \n",
        "4    acquired by Three Cities Research, Inc. and Ce...     474.100000   \n",
        "5    11/7/2011 name change to Resolute Forest Products    8072.000000   \n",
        "6                                                  NaN            NaN   \n",
        "7                                                  NaN     808.550000   \n",
        "8    compact strip process mini-mill sold to Intern...     829.000000   \n",
        "9                                                  NaN    1067.800000   \n",
        "10               Acquired by JDS Uniphase Corp, 5/2005     406.156000   \n",
        "11        acquired by Level 3 Communications 7/24/2006            NaN   \n",
        "12         assets sold to Comcast and TWC on 7-31-2007            NaN   \n",
        "13            Acquired by Kohlberg & Co. LLC 3/31/2006     412.480000   \n",
        "14                                                 NaN     455.834000   \n",
        "15                                                 NaN    3585.045000   \n",
        "16                                                 NaN            NaN   \n",
        "17                                                 NaN     342.129000   \n",
        "18                                                 NaN    1574.400000   \n",
        "19                                                 NaN            NaN   \n",
        "20   Assets sold to Midway Airlines; purchased Poco...            NaN   \n",
        "21   Still existing to 1996; changed name to AFC En...     427.461000   \n",
        "22                                                 NaN            NaN   \n",
        "23   No longer a department store; continuing as a ...     188.057000   \n",
        "24                                                 NaN     850.488000   \n",
        "25                                                 NaN    1441.200000   \n",
        "26   Acquired by Yucaipa Companies, LA Investment c...     613.000000   \n",
        "27   Operates as Allied Automotive Group, Inc. and ...     421.000000   \n",
        "28                                                 NaN     256.611000   \n",
        "29                             Acquired Macy's in 1994    3502.000000   \n",
        "..                                                 ...            ...   \n",
        "965  acquired by American Real Estate Partners LP (...    1297.200000   \n",
        "966  Name changes to WHX corporation; Handy & Harma...    1272.022000   \n",
        "967                                                NaN    1219.675000   \n",
        "968  change name to Wherehouse Entertainment, Inc. New     197.700000   \n",
        "969  acquired by Trans World Entertainment Corporat...     229.075000   \n",
        "970     Name changed to Neoax and then to EnviroSource     630.150000   \n",
        "971             name change to Handy & Harman 1-3-2011            NaN   \n",
        "972  Acquired Collins and Aikman Group 1987 and cha...    1939.100000   \n",
        "973                                                NaN     649.004000   \n",
        "974  Name to change to WilTel Communications Group,...    5992.000000   \n",
        "975           Operating successfully as of August 2004    1084.253000   \n",
        "976  Became subsidiary of Doskocil 10/17/88 and ref...     284.800000   \n",
        "977                                         Continuing    2619.000000   \n",
        "978  acquired by IDT Corp in 2001 and made a subsid...            NaN   \n",
        "979               Acquired by Worldcom from bankruptcy     227.193000   \n",
        "980                                                NaN     831.800000   \n",
        "981                                                NaN            NaN   \n",
        "982           MCI negative earnings 2004, no data 2005  103914.000000   \n",
        "983  sold to group led by  Eli S. Jacobs; continued...     273.000000   \n",
        "984                  Assets purchased by Yazmi USA LLC     340.014000   \n",
        "985                                                NaN            NaN   \n",
        "986        Changed name to TreeSource Industries 10/98     220.930000   \n",
        "987                                                NaN     693.511000   \n",
        "988  Name change to XO Holdings 2-28-2006; 5 years ...    7930.500000   \n",
        "989                                                NaN            NaN   \n",
        "990                                                NaN     263.500000   \n",
        "991                                                NaN     348.222526   \n",
        "992                                    Prosperous 2001    1789.178000   \n",
        "993  Acquired by LGE at confirmation, subsidiary, w...     350.000000   \n",
        "994                                                NaN            NaN   \n",
        "\n",
        "     Assets2Before  Assets3Before   AssetsBefore  AssetsCurrDollar  \\\n",
        "0          690.000            NaN     690.000000               762   \n",
        "1          509.663        439.983     648.000000              1409   \n",
        "2              NaN            NaN     625.902000               635   \n",
        "3              NaN            NaN     339.070000               410   \n",
        "4              NaN            NaN     474.100000               626   \n",
        "5              NaN            NaN    8072.000000              8889   \n",
        "6          279.000            NaN     279.000000               343   \n",
        "7              NaN            NaN     808.550000               878   \n",
        "8          806.000        755.000     829.000000              1190   \n",
        "9              NaN            NaN    1067.800000              1419   \n",
        "10        1015.000            NaN     406.156000               520   \n",
        "11        1890.000            NaN    1890.000000              2482   \n",
        "12       21499.480            NaN   21499.480000             28058   \n",
        "13             NaN            NaN     412.480000               535   \n",
        "14         398.000            NaN     455.834000               605   \n",
        "15             NaN            NaN    3585.045000              3893   \n",
        "16             NaN       2595.000    2595.000000              2812   \n",
        "17             NaN            NaN     342.129000               476   \n",
        "18             NaN            NaN    1574.400000              2039   \n",
        "19         628.000            NaN     628.000000               653   \n",
        "20         229.000        402.021     229.000000               516   \n",
        "21             NaN            NaN     427.461000               742   \n",
        "22        5120.000            NaN    5120.000000              5665   \n",
        "23         198.993        208.000     188.057000               316   \n",
        "24        1282.620       1511.000     850.488000              1721   \n",
        "25             NaN            NaN    1441.200000              1844   \n",
        "26         645.000        403.000     613.000000               897   \n",
        "27             NaN            NaN     421.000000               506   \n",
        "28             NaN            NaN     256.611000               346   \n",
        "29             NaN            NaN    3502.000000              6454   \n",
        "..             ...            ...            ...               ...   \n",
        "965            NaN            NaN    1297.200000              1658   \n",
        "966            NaN            NaN    1272.022000              1715   \n",
        "967       1241.000            NaN    1219.675000              2679   \n",
        "968        351.000        374.000     197.700000               304   \n",
        "969            NaN            NaN     229.075000               296   \n",
        "970        617.763            NaN     630.150000              1761   \n",
        "971        406.000            NaN     406.000000               493   \n",
        "972            NaN            NaN    1939.100000              4797   \n",
        "973            NaN            NaN     649.004000               675   \n",
        "974            NaN            NaN    5992.000000              7824   \n",
        "975       1629.000        754.000    1084.253000              1543   \n",
        "976            NaN            NaN     284.800000               678   \n",
        "977            NaN            NaN    2619.000000              3206   \n",
        "978       3065.000       1663.000    3065.000000              4068   \n",
        "979        318.000        396.000     227.193000               324   \n",
        "980            NaN            NaN     831.800000              1086   \n",
        "981       1630.000            NaN    1630.000000              2163   \n",
        "982            NaN            NaN  103914.000000            135464   \n",
        "983            NaN            NaN     273.000000               555   \n",
        "984            NaN            NaN     340.014000               369   \n",
        "985        314.000        324.000     314.000000               418   \n",
        "986        184.900        146.000     220.930000               385   \n",
        "987            NaN            NaN     693.511000               748   \n",
        "988            NaN            NaN    7930.500000             10350   \n",
        "989        262.000            NaN     262.000000               348   \n",
        "990            NaN            NaN     263.500000               350   \n",
        "991            NaN            NaN     348.222526               385   \n",
        "992       2013.247       1450.000    1789.178000              3042   \n",
        "993            NaN            NaN     350.000000               492   \n",
        "994        300.000            NaN     300.000000               330   \n",
        "\n",
        "     AssetsEmerging  AssetsPetCurrDollar  AssetsPetition      ...       \\\n",
        "0               NaN                  NaN             NaN      ...        \n",
        "1               NaN          1013.036537         466.000      ...        \n",
        "2               NaN           466.680486         459.795      ...        \n",
        "3               NaN           390.484039         323.323      ...        \n",
        "4               NaN           506.177002         383.113      ...        \n",
        "5          7156.000         10942.864900        9937.000      ...        \n",
        "6               NaN            40.713020          33.069      ...        \n",
        "7           874.050           740.899118         682.263      ...        \n",
        "8               NaN          1167.734106         813.700      ...        \n",
        "9               NaN                  NaN             NaN      ...        \n",
        "10              NaN           547.563029         427.964      ...        \n",
        "11              NaN           292.374565         222.661      ...        \n",
        "12              NaN         31856.169280       24409.662      ...        \n",
        "13              NaN           251.912615         194.100      ...        \n",
        "14           53.694                  NaN             NaN      ...        \n",
        "15              NaN           394.197516         363.000      ...        \n",
        "16              NaN                  NaN             NaN      ...        \n",
        "17              NaN                  NaN             NaN      ...        \n",
        "18              NaN                  NaN             NaN      ...        \n",
        "19              NaN                  NaN             NaN      ...        \n",
        "20              NaN           390.173996         173.000      ...        \n",
        "21              NaN           932.698780         537.100      ...        \n",
        "22         1779.700                  NaN             NaN      ...        \n",
        "23           92.917           307.551346         183.000      ...        \n",
        "24          889.800          2586.638948        1278.000      ...        \n",
        "25              NaN          1843.981489        1441.218      ...        \n",
        "26              NaN           748.958704         512.000      ...        \n",
        "27              NaN           158.874885         132.226      ...        \n",
        "28              NaN           185.510723         137.485      ...        \n",
        "29              NaN         20640.087910       11200.000      ...        \n",
        "..              ...                  ...             ...      ...        \n",
        "965             NaN          1706.135762        1334.934      ...        \n",
        "966         878.769          1618.249282        1200.000      ...        \n",
        "967        1218.381          2415.894294        1100.000      ...        \n",
        "968         131.742           270.251511         176.000      ...        \n",
        "969             NaN           294.551307         227.957      ...        \n",
        "970             NaN          2508.523185         897.500      ...        \n",
        "971         296.213           494.187891         406.875      ...        \n",
        "972        1313.008          4218.883449        1705.300      ...        \n",
        "973         581.147                  NaN             NaN      ...        \n",
        "974        2062.273          7824.326231        5992.026      ...        \n",
        "975         787.287           167.958059         118.038      ...        \n",
        "976             NaN           701.247510         294.500      ...        \n",
        "977        1670.891          2737.071512        2236.000      ...        \n",
        "978             NaN                  NaN             NaN      ...        \n",
        "979             NaN           398.050134         278.895      ...        \n",
        "980         742.773                  NaN             NaN      ...        \n",
        "981             NaN          2230.203167        1680.387      ...        \n",
        "982       27470.000        139486.768500      107000.000      ...        \n",
        "983             NaN           638.018385         313.600      ...        \n",
        "984             NaN           333.183072         307.382      ...        \n",
        "985             NaN                  NaN             NaN      ...        \n",
        "986         100.039           267.224734         153.200      ...        \n",
        "987         700.143           748.161825         693.511      ...        \n",
        "988        1348.090         11354.056140        8700.000      ...        \n",
        "989             NaN            66.359808          50.000      ...        \n",
        "990             NaN                  NaN             NaN      ...        \n",
        "991             NaN           636.851761         575.600      ...        \n",
        "992        1013.523          3021.891582        1777.500      ...        \n",
        "993         148.300                  NaN             NaN      ...        \n",
        "994             NaN                  NaN             NaN      ...        \n",
        "\n",
        "      XPrepackaged  XShop                                       XSICMajGroup  \\\n",
        "0               no     No                         60 Depository Institutions   \n",
        "1               no     No                   28 Chemicals and Allied Products   \n",
        "2               no    Yes  36 Electronic And Other Electrical Equipment A...   \n",
        "3               no    Yes  87 Engineering, Accounting, Research, Manageme...   \n",
        "4               no     No  34 Fabricated Metal Products, Except Machinery...   \n",
        "5               no    Yes                       26 Paper and Allied Products   \n",
        "6               no    Yes                              63 Insurance Carriers   \n",
        "7    prenegotiated    Yes                        37 Transportation Equipment   \n",
        "8               no    Yes                        33 Primary Metal Industries   \n",
        "9               no    Yes  36 Electronic And Other Electrical Equipment A...   \n",
        "10   prenegotiated    Yes  38 Measuring, Analyzing and Controlling Instru...   \n",
        "11              no    Yes                                  48 Communications   \n",
        "12              no    Yes                                  48 Communications   \n",
        "13              no    Yes       32 Stone, Clay, Glass, And Concrete Products   \n",
        "14              no    Yes                                  48 Communications   \n",
        "15              no    Yes              61 Non-depository Credit Institutions   \n",
        "16             yes    Yes     27 Printing, Publishing, And Allied Industries   \n",
        "17              no     No                                           01 Crops   \n",
        "18              no     No                       20 Food and Kindred Products   \n",
        "19              no    Yes                               73 Business Services   \n",
        "20              no     No                           45 Transportation By Air   \n",
        "21              no    Yes                      58 Eating and Drinking Places   \n",
        "22              no    Yes                        33 Primary Metal Industries   \n",
        "23              no     No                      53 General Merchandise Stores   \n",
        "24              no     No  36 Electronic And Other Electrical Equipment A...   \n",
        "25              no    Yes                                  48 Communications   \n",
        "26              no     No                   50 Wholesale Trade-durable Goods   \n",
        "27              no    Yes    42 Motor Freight Transportation And Warehousing   \n",
        "28              no     No  35 Industrial and Commercial Machinery and Com...   \n",
        "29              no     No                      53 General Merchandise Stores   \n",
        "..             ...    ...                                                ...   \n",
        "965             no    Yes  23 Apparel And Other Finished Products Made Fr...   \n",
        "966             no    Yes                        33 Primary Metal Industries   \n",
        "967             no     No                        33 Primary Metal Industries   \n",
        "968             no    Yes  57 Home Furniture, Furnishings, and Equipment ...   \n",
        "969             no    Yes  57 Home Furniture, Furnishings, and Equipment ...   \n",
        "970             no    Yes                        37 Transportation Equipment   \n",
        "971             no     No  34 Fabricated Metal Products, Except Machinery...   \n",
        "972             no     No  52 Building Materials, Hardware, Garden Supply...   \n",
        "973            yes    Yes  15 Building Construction General Contractors A...   \n",
        "974  prenegotiated    Yes                                  48 Communications   \n",
        "975            yes    Yes              61 Non-depository Credit Institutions   \n",
        "976             no     No                       20 Food and Kindred Products   \n",
        "977             no    Yes                                     54 Food Stores   \n",
        "978             no    Yes                                  48 Communications   \n",
        "979  prenegotiated    Yes                                  48 Communications   \n",
        "980  prenegotiated    Yes       32 Stone, Clay, Glass, And Concrete Products   \n",
        "981             no    Yes  36 Electronic And Other Electrical Equipment A...   \n",
        "982             no    Yes                                  48 Communications   \n",
        "983             no     No                            59 Miscellaneous Retail   \n",
        "984             no    Yes                                  48 Communications   \n",
        "985  prenegotiated    Yes                           22 Textile Mill Products   \n",
        "986             no    Yes      24 Lumber And Wood Products, Except Furniture   \n",
        "987            yes    Yes                           22 Textile Mill Products   \n",
        "988  prenegotiated    Yes                                  48 Communications   \n",
        "989             no     No                               73 Business Services   \n",
        "990             no     No            49 Electric, Gas, And Sanitary Services   \n",
        "991             no     No                                  48 Communications   \n",
        "992             no     No                            59 Miscellaneous Retail   \n",
        "993            yes    Yes  36 Electronic And Other Electrical Equipment A...   \n",
        "994  prenegotiated     No     27 Printing, Publishing, And Allied Industries   \n",
        "\n",
        "         XTortCause           XVoluntary XYearDisposed XYearEmerged  \\\n",
        "0          Not tort  voluntary Chapter 7           NaN          NaN   \n",
        "1    Other products            voluntary          1988         1988   \n",
        "2          Not tort            voluntary          2013         2012   \n",
        "3            Fraud?            voluntary          2006         2006   \n",
        "4          Not tort            voluntary          2004         2001   \n",
        "5          Not tort            voluntary          2010         2010   \n",
        "6          Not tort            voluntary          2010          NaN   \n",
        "7          Not tort            voluntary          2010         2010   \n",
        "8          Not tort            voluntary          2002          NaN   \n",
        "9          Not tort            voluntary          2003          NaN   \n",
        "10         Not tort            voluntary          2003         2003   \n",
        "11            Fraud            voluntary          2003         2003   \n",
        "12            Fraud            voluntary          2007          NaN   \n",
        "13         Not tort            voluntary          2004         2004   \n",
        "14         Not tort            voluntary          2001         2001   \n",
        "15         Not tort            voluntary          2011          NaN   \n",
        "16         Not tort            voluntary          2010         2010   \n",
        "17         Not tort            voluntary          2001          NaN   \n",
        "18         Not tort            voluntary          2004          NaN   \n",
        "19         Not tort            voluntary          2013         2013   \n",
        "20         Not tort            voluntary          1986         1984   \n",
        "21         Not tort          involuntary          1992         1992   \n",
        "22         Not tort            voluntary          2010         2010   \n",
        "23         Not tort            voluntary          1993         1993   \n",
        "24         Not tort            voluntary          1990         1990   \n",
        "25         Not tort            voluntary          2004          NaN   \n",
        "26         Not tort            voluntary          1998         1998   \n",
        "27         Not tort            voluntary          2007         2007   \n",
        "28         Not tort            voluntary          2003          NaN   \n",
        "29         Not tort            voluntary          1992         1992   \n",
        "..              ...                  ...           ...          ...   \n",
        "965        Not tort            voluntary          2012         2005   \n",
        "966        Not tort            voluntary          2003         2003   \n",
        "967         Pension            voluntary          1990         1990   \n",
        "968        Not tort            voluntary          1997         1997   \n",
        "969        Not tort            voluntary          2004          NaN   \n",
        "970        Not tort            voluntary          1983         1983   \n",
        "971        Not tort            voluntary          2005         2005   \n",
        "972        Not tort            voluntary          1984         1984   \n",
        "973        Not tort            voluntary          2012         2012   \n",
        "974        Not tort            voluntary          2002         2002   \n",
        "975        Not tort            voluntary          1999         1999   \n",
        "976        Not tort            voluntary          1984         1984   \n",
        "977        Not tort            voluntary          2006         2006   \n",
        "978        Not tort            voluntary          2002         2001   \n",
        "979        Not tort            voluntary          1999         1999   \n",
        "980        Not tort            voluntary          2002         2002   \n",
        "981        Not tort          involuntary          2004          NaN   \n",
        "982           Fraud            voluntary          2003         2003   \n",
        "983        Not tort            voluntary          1989         1989   \n",
        "984        Not tort            voluntary          2012         2010   \n",
        "985        Not tort            voluntary          2002         2002   \n",
        "986        Not tort            voluntary          1992         1992   \n",
        "987        Not tort            voluntary          2010         2010   \n",
        "988        Not tort            voluntary          2002         2002   \n",
        "989        Not tort            voluntary          2002          NaN   \n",
        "990        Not tort          involuntary          2002          NaN   \n",
        "991        Not tort            voluntary          2010         2010   \n",
        "992        Not tort          involuntary          1993         1993   \n",
        "993        Not tort            voluntary          1999         1999   \n",
        "994        Not tort            voluntary          2008         2008   \n",
        "\n",
        "    XYearFiled YearConfirmed YearsToRefile  \n",
        "0         2009           NaN           NaN  \n",
        "1         1985          1988           NaN  \n",
        "2         2012          2013           NaN  \n",
        "3         2005          2006           NaN  \n",
        "4         2001           NaN           NaN  \n",
        "5         2009          2010           NaN  \n",
        "6         2005           NaN           NaN  \n",
        "7         2009          2010           NaN  \n",
        "8         1998          2002           NaN  \n",
        "9         2001          2003           NaN  \n",
        "10        2003          2003           NaN  \n",
        "11        2002          2003           NaN  \n",
        "12        2002          2007           NaN  \n",
        "13        2002          2004           NaN  \n",
        "14        2001          2001           NaN  \n",
        "15        2009          2011           NaN  \n",
        "16        2010          2010           NaN  \n",
        "17        2000          2001           NaN  \n",
        "18        2002          2004           NaN  \n",
        "19        2011          2013           NaN  \n",
        "20        1984          1986      3.693150  \n",
        "21        1991          1992           NaN  \n",
        "22        2009          2010           NaN  \n",
        "23        1992          1993           NaN  \n",
        "24        1988          1990     10.580821  \n",
        "25        2003          2004           NaN  \n",
        "26        1997          1998           NaN  \n",
        "27        2005          2007      5.002739  \n",
        "28        2000          2003           NaN  \n",
        "29        1990          1992           NaN  \n",
        "..         ...           ...           ...  \n",
        "965       2003           NaN           NaN  \n",
        "966       2000          2003           NaN  \n",
        "967       1985          1990      9.920547  \n",
        "968       1995          1997      6.038356  \n",
        "969       2003          2004           NaN  \n",
        "970       1980          1983           NaN  \n",
        "971       2005          2005           NaN  \n",
        "972       1982          1984           NaN  \n",
        "973       2011          2012           NaN  \n",
        "974       2002          2002           NaN  \n",
        "975       1999          1999           NaN  \n",
        "976       1983          1984      5.939726  \n",
        "977       2005          2006           NaN  \n",
        "978       2001           NaN           NaN  \n",
        "979       1999          1999           NaN  \n",
        "980       2002          2002           NaN  \n",
        "981       2001          2004           NaN  \n",
        "982       2002          2003           NaN  \n",
        "983       1987          1989           NaN  \n",
        "984       2008           NaN           NaN  \n",
        "985       2001          2002           NaN  \n",
        "986       1991          1992      6.846575  \n",
        "987       2010          2010           NaN  \n",
        "988       2002          2002           NaN  \n",
        "989       2001          2002           NaN  \n",
        "990       2001          2002           NaN  \n",
        "991       2009          2010           NaN  \n",
        "992       1992          1993           NaN  \n",
        "993       1999          1999           NaN  \n",
        "994       2008          2008           NaN  \n",
        "\n",
        "[995 rows x 203 columns]"
       ]
      }
     ],
     "prompt_number": 5
    },
    {
     "cell_type": "heading",
     "level": 1,
     "metadata": {},
     "source": [
      "Fields used in the BRD database"
     ]
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "list(brd.columns.values)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 7,
       "text": [
        "['XNameCorp',\n",
        " 'AfterEmerging',\n",
        " 'Assets1Before',\n",
        " 'Assets2Before',\n",
        " 'Assets3Before',\n",
        " 'AssetsBefore',\n",
        " 'AssetsCurrDollar',\n",
        " 'AssetsEmerging',\n",
        " 'AssetsPetCurrDollar',\n",
        " 'AssetsPetition',\n",
        " 'BondISIN',\n",
        " 'BondPriceDisp',\n",
        " 'BondPriceFile',\n",
        " 'BondPriceMoveDuring',\n",
        " 'CaseNum',\n",
        " 'CaseNumRefile',\n",
        " 'CaseNumTransfer',\n",
        " 'CeoFiling',\n",
        " 'CeoNotes',\n",
        " 'CeoSaleExit',\n",
        " 'CikBefore',\n",
        " 'CikEmerging',\n",
        " 'CityChange',\n",
        " 'CityDisposed',\n",
        " 'CityRefile',\n",
        " 'ClaimsAgentPetition',\n",
        " 'ClaimsSecDiscloState',\n",
        " 'ClaimsUnsec',\n",
        " 'CommCred',\n",
        " 'CommCredAttyCol',\n",
        " 'CommCredAttyRes',\n",
        " 'CommCredAttySubstit',\n",
        " 'CommEquity',\n",
        " 'CommEquityAttyCol',\n",
        " 'CommEquityAttyRes',\n",
        " 'CommEquityAttySubstit',\n",
        " 'CommEquityName',\n",
        " 'CommRetirees',\n",
        " 'CommRetireesName',\n",
        " 'CommRetireesRequest',\n",
        " 'CommonName',\n",
        " 'CPIndexAtConf',\n",
        " 'CPIndexAtFiling',\n",
        " 'Cusip6',\n",
        " 'Cusip9',\n",
        " 'Date10k1Before',\n",
        " 'Date10k2Before',\n",
        " 'Date10k3Before',\n",
        " 'Date10kBefore',\n",
        " 'Date10kBeforeLink',\n",
        " 'Date10kDuring',\n",
        " 'Date10kDuringLink',\n",
        " 'Date10kEmerging',\n",
        " 'Date10kEmergLink',\n",
        " 'Date10kSalesEmerge',\n",
        " 'Date363Sale',\n",
        " 'DateCeoBegin',\n",
        " 'DateCeoEnd',\n",
        " 'DateConfirmed',\n",
        " 'DateConvDismiss',\n",
        " 'DateDiscloState',\n",
        " 'DateDisposed',\n",
        " 'DateEffective',\n",
        " 'DateEmerging',\n",
        " 'DateFeeRev',\n",
        " 'DateFiled',\n",
        " 'DateRefile',\n",
        " 'DateTransferred',\n",
        " 'DateTurnEngage',\n",
        " 'DaysDocsAfter',\n",
        " 'DaysTo363',\n",
        " 'DaysToRefile',\n",
        " 'DENYOther',\n",
        " 'DipAttyColDoc',\n",
        " 'DipAttyResDoc',\n",
        " 'DipAttySubstitDoc',\n",
        " 'DipFinAdvPetition',\n",
        " 'DipLoan',\n",
        " 'DipLoanAdditional',\n",
        " 'DipLoan1Lender',\n",
        " 'DipLoan1Total',\n",
        " 'DipLoan2Lender',\n",
        " 'DipLoan2Total',\n",
        " 'DistribComments',\n",
        " 'DistribEquity',\n",
        " 'DistribSecDiscloState',\n",
        " 'DistribUnsec',\n",
        " 'DistribUnsecPct',\n",
        " 'DktNumConf',\n",
        " 'DktOnPacer',\n",
        " 'DocsOnPacer',\n",
        " 'DocsPublic',\n",
        " 'EbitBefore',\n",
        " 'EbitdaBefore',\n",
        " 'EbitdaEmerging',\n",
        " 'EbitEmerging',\n",
        " 'Emerge',\n",
        " 'Emerg10k',\n",
        " 'EmplEmerging',\n",
        " 'EmplUnionBefore',\n",
        " 'EmplUnionEmerging',\n",
        " 'Examiner',\n",
        " 'ExaminerName',\n",
        " 'ExaminerRequest',\n",
        " 'FeeReviewer',\n",
        " 'FilingRate',\n",
        " 'FreshStartAccounting',\n",
        " 'GdpDisp',\n",
        " 'GdpFiling',\n",
        " 'GdpRefiling',\n",
        " 'GdpYear1AftDisp',\n",
        " 'GdpYear1BefFile',\n",
        " 'GdpYear2AftDisp',\n",
        " 'GdpYear2BefFile',\n",
        " 'GvkeyBefore',\n",
        " 'GvkeyEmerging',\n",
        " 'HeadCAtFiling',\n",
        " 'HeadCourtCity',\n",
        " 'HeadCourtCityToDE',\n",
        " 'HeadStAtFiling',\n",
        " 'HqToForum',\n",
        " 'HqToHqCtCity',\n",
        " 'IncomeBEBefore',\n",
        " 'IncomeBEEmerging',\n",
        " 'InterCompClaims',\n",
        " 'InterCompPct',\n",
        " 'InterCompTreat',\n",
        " 'JudgeConfirmation',\n",
        " 'JudgeFiling',\n",
        " 'Liab1Before',\n",
        " 'Liab2Before',\n",
        " 'Liab3Before',\n",
        " 'LiabBefore',\n",
        " 'LiabCurrDollar',\n",
        " 'LiabEmerging',\n",
        " 'LiabPetCurrDollar',\n",
        " 'LiabPetition',\n",
        " 'MonthFiled',\n",
        " 'MonthDisp',\n",
        " 'MonthRefile',\n",
        " 'MonthsIn',\n",
        " 'Multiple363Sales',\n",
        " 'NameEmerging',\n",
        " 'NetIncomeBefore',\n",
        " 'NetIncomeEmerging',\n",
        " 'NumberFiling',\n",
        " 'PrimaryKey',\n",
        " 'Prime1YearAftDisp',\n",
        " 'Prime1YearBefFile',\n",
        " 'Prime2YearAftDisp',\n",
        " 'Prime2YearBefFile',\n",
        " 'PrimeDisp',\n",
        " 'PrimeFiling',\n",
        " 'PrimeRefiling',\n",
        " 'ProfFees10k',\n",
        " 'ProfFees10kNotes',\n",
        " 'Refile',\n",
        " 'Refile5',\n",
        " 'Refile5RepRange',\n",
        " 'RelatedFilings',\n",
        " 'Sale363',\n",
        " 'SaleIntended',\n",
        " 'Sales1Before',\n",
        " 'Sales2Before',\n",
        " 'Sales3Before',\n",
        " 'SalesBefore',\n",
        " 'SalesCurrDollar',\n",
        " 'SalesEmerging',\n",
        " 'SICDescription',\n",
        " 'SICDivision',\n",
        " 'SICIndustryGroup',\n",
        " 'SICPrimary',\n",
        " 'SubCon',\n",
        " 'Ticker',\n",
        " 'TransCity',\n",
        " 'Transferred',\n",
        " 'Trustee',\n",
        " 'TrusteeFor',\n",
        " 'TrusteeName',\n",
        " 'TrusteeRequest',\n",
        " 'TrusteeRequestor',\n",
        " 'TurnFirm',\n",
        " 'TurnOffice',\n",
        " 'TurnPerson',\n",
        " 'TurnRepRange',\n",
        " 'TurnType',\n",
        " 'XChapter',\n",
        " 'XCityFiled',\n",
        " 'XConfirmed',\n",
        " 'XDaysIn',\n",
        " 'XDistFiled',\n",
        " 'XIncPublic',\n",
        " 'XNumEmplBefore',\n",
        " 'XPrepackaged',\n",
        " 'XShop',\n",
        " 'XSICMajGroup',\n",
        " 'XTortCause',\n",
        " 'XVoluntary',\n",
        " 'XYearDisposed',\n",
        " 'XYearEmerged',\n",
        " 'XYearFiled',\n",
        " 'YearConfirmed',\n",
        " 'YearsToRefile']"
       ]
      }
     ],
     "prompt_number": 7
    }
   ],
   "metadata": {}
  }
 ]
}